﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Claim_DataSet" targetNamespace="http://tempuri.org/Claim_DataSet.xsd" xmlns:mstns="http://tempuri.org/Claim_DataSet.xsd" xmlns="http://tempuri.org/Claim_DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CDMS" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CDMS (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TestReport.Properties.Settings.GlobalReference.Default.CDMS" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClaimTableAdapter" GeneratorDataComponentClassName="ClaimTableAdapter" Name="Claim" UserDataComponentName="ClaimTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CDMS (Settings)" DbObjectName="CDMS_UAT.dbo.Claim" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Claim] WHERE (([Id] = @Original_Id) AND ([EntryOwner] = @Original_EntryOwner) AND ([EntryDateTime] = @Original_EntryDateTime) AND ([ClaimDate] = @Original_ClaimDate) AND ((@IsNull_StartWorkTime = 1 AND [StartWorkTime] IS NULL) OR ([StartWorkTime] = @Original_StartWorkTime)) AND ((@IsNull_EndWorkTime = 1 AND [EndWorkTime] IS NULL) OR ([EndWorkTime] = @Original_EndWorkTime)) AND ((@IsNull_StartOverTime = 1 AND [StartOverTime] IS NULL) OR ([StartOverTime] = @Original_StartOverTime)) AND ((@IsNull_EndOverTime = 1 AND [EndOverTime] IS NULL) OR ([EndOverTime] = @Original_EndOverTime)) AND ((@IsNull_OT1_5 = 1 AND [OT1_5] IS NULL) OR ([OT1_5] = @Original_OT1_5)) AND ((@IsNull_OT2_0 = 1 AND [OT2_0] IS NULL) OR ([OT2_0] = @Original_OT2_0)) AND ((@IsNull_PH = 1 AND [PH] IS NULL) OR ([PH] = @Original_PH)) AND ((@IsNull_RD4 = 1 AND [RD4] IS NULL) OR ([RD4] = @Original_RD4)) AND ((@IsNull_RD8 = 1 AND [RD8] IS NULL) OR ([RD8] = @Original_RD8)) AND ((@IsNull_AlwShft = 1 AND [AlwShft] IS NULL) OR ([AlwShft] = @Original_AlwShft)) AND ((@IsNull_AlwMeal = 1 AND [AlwMeal] IS NULL) OR ([AlwMeal] = @Original_AlwMeal)) AND ((@IsNull_ShiftType = 1 AND [ShiftType] IS NULL) OR ([ShiftType] = @Original_ShiftType)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_SubmissionDate = 1 AND [SubmissionDate] IS NULL) OR ([SubmissionDate] = @Original_SubmissionDate)) AND ((@IsNull_RecommenderId = 1 AND [RecommenderId] IS NULL) OR ([RecommenderId] = @Original_RecommenderId)) AND ((@IsNull_RecommendDate = 1 AND [RecommendDate] IS NULL) OR ([RecommendDate] = @Original_RecommendDate)) AND ((@IsNull_ApproverId = 1 AND [ApproverId] IS NULL) OR ([ApproverId] = @Original_ApproverId)) AND ((@IsNull_ApprovingDate = 1 AND [ApprovingDate] IS NULL) OR ([ApprovingDate] = @Original_ApprovingDate)) AND ((@IsNull_RejectorId = 1 AND [RejectorId] IS NULL) OR ([RejectorId] = @Original_RejectorId)) AND ((@IsNull_RejectionDate = 1 AND [RejectionDate] IS NULL) OR ([RejectionDate] = @Original_RejectionDate)) AND ((@IsNull_Exported = 1 AND [Exported] IS NULL) OR ([Exported] = @Original_Exported)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EntryOwner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EntryOwner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EntryDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryDateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ClaimDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ClaimDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartWorkTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartWorkTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartWorkTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndWorkTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndWorkTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndWorkTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartOverTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartOverTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartOverTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartOverTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndOverTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndOverTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndOverTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndOverTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OT1_5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OT1_5" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OT1_5" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OT1_5" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OT2_0" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OT2_0" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OT2_0" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OT2_0" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PH" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RD4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RD4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_RD4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RD4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RD8" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RD8" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_RD8" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RD8" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AlwShft" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AlwShft" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AlwShft" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AlwShft" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AlwMeal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AlwMeal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AlwMeal" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AlwMeal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShiftType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShiftType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShiftType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShiftType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SubmissionDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubmissionDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_SubmissionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SubmissionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RecommenderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecommenderId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RecommenderId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecommenderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RecommendDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecommendDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RecommendDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RecommendDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApproverId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApproverId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ApproverId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApproverId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovingDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovingDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ApprovingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovingDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RejectorId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RejectorId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RejectorId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RejectorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RejectionDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RejectionDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RejectionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RejectionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Exported" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Exported" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Exported" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Exported" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Claim] ([EntryOwner], [EntryDateTime], [ClaimDate], [StartWorkTime], [EndWorkTime], [StartOverTime], [EndOverTime], [OT1_5], [OT2_0], [PH], [RD4], [RD8], [AlwShft], [AlwMeal], [ShiftType], [Remark], [Status], [SubmissionDate], [RecommenderId], [RecommendDate], [ApproverId], [ApprovingDate], [RejectorId], [RejectionDate], [RejectReason], [Exported]) VALUES (@EntryOwner, @EntryDateTime, @ClaimDate, @StartWorkTime, @EndWorkTime, @StartOverTime, @EndOverTime, @OT1_5, @OT2_0, @PH, @RD4, @RD8, @AlwShft, @AlwMeal, @ShiftType, @Remark, @Status, @SubmissionDate, @RecommenderId, @RecommendDate, @ApproverId, @ApprovingDate, @RejectorId, @RejectionDate, @RejectReason, @Exported);
SELECT Id, EntryOwner, EntryDateTime, ClaimDate, StartWorkTime, EndWorkTime, StartOverTime, EndOverTime, OT1_5, OT2_0, PH, RD4, RD8, AlwShft, AlwMeal, ShiftType, Remark, Status, SubmissionDate, RecommenderId, RecommendDate, ApproverId, ApprovingDate, RejectorId, RejectionDate, RejectReason, Exported FROM Claim WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EntryOwner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EntryOwner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EntryDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ClaimDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ClaimDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartWorkTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndWorkTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartOverTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartOverTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndOverTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndOverTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OT1_5" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OT1_5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OT2_0" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OT2_0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PH" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@RD4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RD4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@RD8" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RD8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AlwShft" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AlwShft" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AlwMeal" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AlwMeal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShiftType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShiftType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SubmissionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SubmissionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RecommenderId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecommenderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RecommendDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RecommendDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ApproverId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApproverId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ApprovingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovingDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RejectorId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RejectorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RejectionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RejectionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RejectReason" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RejectReason" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Exported" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Exported" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, EntryOwner, EntryDateTime, ClaimDate, StartWorkTime, EndWorkTime, StartOverTime, EndOverTime, OT1_5, OT2_0, PH, RD4, RD8, AlwShft, AlwMeal, ShiftType, Remark, Status, SubmissionDate, RecommenderId, RecommendDate, ApproverId, ApprovingDate, RejectorId, RejectionDate, RejectReason, Exported FROM dbo.Claim</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Claim] SET [EntryOwner] = @EntryOwner, [EntryDateTime] = @EntryDateTime, [ClaimDate] = @ClaimDate, [StartWorkTime] = @StartWorkTime, [EndWorkTime] = @EndWorkTime, [StartOverTime] = @StartOverTime, [EndOverTime] = @EndOverTime, [OT1_5] = @OT1_5, [OT2_0] = @OT2_0, [PH] = @PH, [RD4] = @RD4, [RD8] = @RD8, [AlwShft] = @AlwShft, [AlwMeal] = @AlwMeal, [ShiftType] = @ShiftType, [Remark] = @Remark, [Status] = @Status, [SubmissionDate] = @SubmissionDate, [RecommenderId] = @RecommenderId, [RecommendDate] = @RecommendDate, [ApproverId] = @ApproverId, [ApprovingDate] = @ApprovingDate, [RejectorId] = @RejectorId, [RejectionDate] = @RejectionDate, [RejectReason] = @RejectReason, [Exported] = @Exported WHERE (([Id] = @Original_Id) AND ([EntryOwner] = @Original_EntryOwner) AND ([EntryDateTime] = @Original_EntryDateTime) AND ([ClaimDate] = @Original_ClaimDate) AND ((@IsNull_StartWorkTime = 1 AND [StartWorkTime] IS NULL) OR ([StartWorkTime] = @Original_StartWorkTime)) AND ((@IsNull_EndWorkTime = 1 AND [EndWorkTime] IS NULL) OR ([EndWorkTime] = @Original_EndWorkTime)) AND ((@IsNull_StartOverTime = 1 AND [StartOverTime] IS NULL) OR ([StartOverTime] = @Original_StartOverTime)) AND ((@IsNull_EndOverTime = 1 AND [EndOverTime] IS NULL) OR ([EndOverTime] = @Original_EndOverTime)) AND ((@IsNull_OT1_5 = 1 AND [OT1_5] IS NULL) OR ([OT1_5] = @Original_OT1_5)) AND ((@IsNull_OT2_0 = 1 AND [OT2_0] IS NULL) OR ([OT2_0] = @Original_OT2_0)) AND ((@IsNull_PH = 1 AND [PH] IS NULL) OR ([PH] = @Original_PH)) AND ((@IsNull_RD4 = 1 AND [RD4] IS NULL) OR ([RD4] = @Original_RD4)) AND ((@IsNull_RD8 = 1 AND [RD8] IS NULL) OR ([RD8] = @Original_RD8)) AND ((@IsNull_AlwShft = 1 AND [AlwShft] IS NULL) OR ([AlwShft] = @Original_AlwShft)) AND ((@IsNull_AlwMeal = 1 AND [AlwMeal] IS NULL) OR ([AlwMeal] = @Original_AlwMeal)) AND ((@IsNull_ShiftType = 1 AND [ShiftType] IS NULL) OR ([ShiftType] = @Original_ShiftType)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_SubmissionDate = 1 AND [SubmissionDate] IS NULL) OR ([SubmissionDate] = @Original_SubmissionDate)) AND ((@IsNull_RecommenderId = 1 AND [RecommenderId] IS NULL) OR ([RecommenderId] = @Original_RecommenderId)) AND ((@IsNull_RecommendDate = 1 AND [RecommendDate] IS NULL) OR ([RecommendDate] = @Original_RecommendDate)) AND ((@IsNull_ApproverId = 1 AND [ApproverId] IS NULL) OR ([ApproverId] = @Original_ApproverId)) AND ((@IsNull_ApprovingDate = 1 AND [ApprovingDate] IS NULL) OR ([ApprovingDate] = @Original_ApprovingDate)) AND ((@IsNull_RejectorId = 1 AND [RejectorId] IS NULL) OR ([RejectorId] = @Original_RejectorId)) AND ((@IsNull_RejectionDate = 1 AND [RejectionDate] IS NULL) OR ([RejectionDate] = @Original_RejectionDate)) AND ((@IsNull_Exported = 1 AND [Exported] IS NULL) OR ([Exported] = @Original_Exported)));
SELECT Id, EntryOwner, EntryDateTime, ClaimDate, StartWorkTime, EndWorkTime, StartOverTime, EndOverTime, OT1_5, OT2_0, PH, RD4, RD8, AlwShft, AlwMeal, ShiftType, Remark, Status, SubmissionDate, RecommenderId, RecommendDate, ApproverId, ApprovingDate, RejectorId, RejectionDate, RejectReason, Exported FROM Claim WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EntryOwner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EntryOwner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EntryDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ClaimDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ClaimDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartWorkTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndWorkTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartOverTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartOverTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndOverTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndOverTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OT1_5" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OT1_5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OT2_0" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OT2_0" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PH" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@RD4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RD4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@RD8" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RD8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AlwShft" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AlwShft" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AlwMeal" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AlwMeal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShiftType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShiftType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Remark" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Remark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SubmissionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SubmissionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RecommenderId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecommenderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RecommendDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RecommendDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ApproverId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApproverId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ApprovingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovingDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RejectorId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RejectorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RejectionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RejectionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RejectReason" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RejectReason" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Exported" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Exported" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EntryOwner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EntryOwner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EntryDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryDateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ClaimDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ClaimDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartWorkTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartWorkTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartWorkTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndWorkTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndWorkTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndWorkTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndWorkTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartOverTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartOverTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartOverTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartOverTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndOverTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndOverTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndOverTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndOverTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OT1_5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OT1_5" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OT1_5" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OT1_5" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OT2_0" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OT2_0" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OT2_0" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OT2_0" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PH" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RD4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RD4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_RD4" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RD4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RD8" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RD8" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_RD8" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="RD8" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AlwShft" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AlwShft" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AlwShft" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AlwShft" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AlwMeal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AlwMeal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AlwMeal" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AlwMeal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShiftType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShiftType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShiftType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ShiftType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SubmissionDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubmissionDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_SubmissionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SubmissionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RecommenderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecommenderId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RecommenderId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecommenderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RecommendDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecommendDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RecommendDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RecommendDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApproverId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApproverId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ApproverId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApproverId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovingDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovingDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ApprovingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovingDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RejectorId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RejectorId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RejectorId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RejectorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RejectionDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RejectionDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RejectionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RejectionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Exported" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Exported" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Exported" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Exported" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="CDMS_UAT.dbo.Claim" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="EntryOwner" DataSetColumn="EntryOwner" />
              <Mapping SourceColumn="EntryDateTime" DataSetColumn="EntryDateTime" />
              <Mapping SourceColumn="ClaimDate" DataSetColumn="ClaimDate" />
              <Mapping SourceColumn="StartWorkTime" DataSetColumn="StartWorkTime" />
              <Mapping SourceColumn="EndWorkTime" DataSetColumn="EndWorkTime" />
              <Mapping SourceColumn="StartOverTime" DataSetColumn="StartOverTime" />
              <Mapping SourceColumn="EndOverTime" DataSetColumn="EndOverTime" />
              <Mapping SourceColumn="OT1_5" DataSetColumn="OT1_5" />
              <Mapping SourceColumn="OT2_0" DataSetColumn="OT2_0" />
              <Mapping SourceColumn="PH" DataSetColumn="PH" />
              <Mapping SourceColumn="RD4" DataSetColumn="RD4" />
              <Mapping SourceColumn="RD8" DataSetColumn="RD8" />
              <Mapping SourceColumn="AlwShft" DataSetColumn="AlwShft" />
              <Mapping SourceColumn="AlwMeal" DataSetColumn="AlwMeal" />
              <Mapping SourceColumn="ShiftType" DataSetColumn="ShiftType" />
              <Mapping SourceColumn="Remark" DataSetColumn="Remark" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="SubmissionDate" DataSetColumn="SubmissionDate" />
              <Mapping SourceColumn="RecommenderId" DataSetColumn="RecommenderId" />
              <Mapping SourceColumn="RecommendDate" DataSetColumn="RecommendDate" />
              <Mapping SourceColumn="ApproverId" DataSetColumn="ApproverId" />
              <Mapping SourceColumn="ApprovingDate" DataSetColumn="ApprovingDate" />
              <Mapping SourceColumn="RejectorId" DataSetColumn="RejectorId" />
              <Mapping SourceColumn="RejectionDate" DataSetColumn="RejectionDate" />
              <Mapping SourceColumn="RejectReason" DataSetColumn="RejectReason" />
              <Mapping SourceColumn="Exported" DataSetColumn="Exported" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Claim_DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Claim_DataSet" msprop:Generator_UserDSName="Claim_DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Claim" msprop:Generator_TableClassName="ClaimDataTable" msprop:Generator_TableVarName="tableClaim" msprop:Generator_TablePropName="Claim" msprop:Generator_RowDeletingName="ClaimRowDeleting" msprop:Generator_RowChangingName="ClaimRowChanging" msprop:Generator_RowEvHandlerName="ClaimRowChangeEventHandler" msprop:Generator_RowDeletedName="ClaimRowDeleted" msprop:Generator_UserTableName="Claim" msprop:Generator_RowChangedName="ClaimRowChanged" msprop:Generator_RowEvArgName="ClaimRowChangeEvent" msprop:Generator_RowClassName="ClaimRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="EntryOwner" msprop:Generator_ColumnVarNameInTable="columnEntryOwner" msprop:Generator_ColumnPropNameInRow="EntryOwner" msprop:Generator_ColumnPropNameInTable="EntryOwnerColumn" msprop:Generator_UserColumnName="EntryOwner">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EntryDateTime" msprop:Generator_ColumnVarNameInTable="columnEntryDateTime" msprop:Generator_ColumnPropNameInRow="EntryDateTime" msprop:Generator_ColumnPropNameInTable="EntryDateTimeColumn" msprop:Generator_UserColumnName="EntryDateTime" type="xs:dateTime" />
              <xs:element name="ClaimDate" msprop:Generator_ColumnVarNameInTable="columnClaimDate" msprop:Generator_ColumnPropNameInRow="ClaimDate" msprop:Generator_ColumnPropNameInTable="ClaimDateColumn" msprop:Generator_UserColumnName="ClaimDate" type="xs:dateTime" />
              <xs:element name="StartWorkTime" msprop:Generator_ColumnVarNameInTable="columnStartWorkTime" msprop:Generator_ColumnPropNameInRow="StartWorkTime" msprop:Generator_ColumnPropNameInTable="StartWorkTimeColumn" msprop:Generator_UserColumnName="StartWorkTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndWorkTime" msprop:Generator_ColumnVarNameInTable="columnEndWorkTime" msprop:Generator_ColumnPropNameInRow="EndWorkTime" msprop:Generator_ColumnPropNameInTable="EndWorkTimeColumn" msprop:Generator_UserColumnName="EndWorkTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="StartOverTime" msprop:Generator_ColumnVarNameInTable="columnStartOverTime" msprop:Generator_ColumnPropNameInRow="StartOverTime" msprop:Generator_ColumnPropNameInTable="StartOverTimeColumn" msprop:Generator_UserColumnName="StartOverTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndOverTime" msprop:Generator_ColumnVarNameInTable="columnEndOverTime" msprop:Generator_ColumnPropNameInRow="EndOverTime" msprop:Generator_ColumnPropNameInTable="EndOverTimeColumn" msprop:Generator_UserColumnName="EndOverTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="OT1_5" msprop:Generator_ColumnVarNameInTable="columnOT1_5" msprop:Generator_ColumnPropNameInRow="OT1_5" msprop:Generator_ColumnPropNameInTable="OT1_5Column" msprop:Generator_UserColumnName="OT1_5" type="xs:decimal" minOccurs="0" />
              <xs:element name="OT2_0" msprop:Generator_ColumnVarNameInTable="columnOT2_0" msprop:Generator_ColumnPropNameInRow="OT2_0" msprop:Generator_ColumnPropNameInTable="OT2_0Column" msprop:Generator_UserColumnName="OT2_0" type="xs:decimal" minOccurs="0" />
              <xs:element name="PH" msprop:Generator_ColumnVarNameInTable="columnPH" msprop:Generator_ColumnPropNameInRow="PH" msprop:Generator_ColumnPropNameInTable="PHColumn" msprop:Generator_UserColumnName="PH" type="xs:boolean" minOccurs="0" />
              <xs:element name="RD4" msprop:Generator_ColumnVarNameInTable="columnRD4" msprop:Generator_ColumnPropNameInRow="RD4" msprop:Generator_ColumnPropNameInTable="RD4Column" msprop:Generator_UserColumnName="RD4" type="xs:boolean" minOccurs="0" />
              <xs:element name="RD8" msprop:Generator_ColumnVarNameInTable="columnRD8" msprop:Generator_ColumnPropNameInRow="RD8" msprop:Generator_ColumnPropNameInTable="RD8Column" msprop:Generator_UserColumnName="RD8" type="xs:boolean" minOccurs="0" />
              <xs:element name="AlwShft" msprop:Generator_ColumnVarNameInTable="columnAlwShft" msprop:Generator_ColumnPropNameInRow="AlwShft" msprop:Generator_ColumnPropNameInTable="AlwShftColumn" msprop:Generator_UserColumnName="AlwShft" type="xs:decimal" minOccurs="0" />
              <xs:element name="AlwMeal" msprop:Generator_ColumnVarNameInTable="columnAlwMeal" msprop:Generator_ColumnPropNameInRow="AlwMeal" msprop:Generator_ColumnPropNameInTable="AlwMealColumn" msprop:Generator_UserColumnName="AlwMeal" type="xs:decimal" minOccurs="0" />
              <xs:element name="ShiftType" msprop:Generator_ColumnVarNameInTable="columnShiftType" msprop:Generator_ColumnPropNameInRow="ShiftType" msprop:Generator_ColumnPropNameInTable="ShiftTypeColumn" msprop:Generator_UserColumnName="ShiftType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Remark" msprop:Generator_ColumnVarNameInTable="columnRemark" msprop:Generator_ColumnPropNameInRow="Remark" msprop:Generator_ColumnPropNameInTable="RemarkColumn" msprop:Generator_UserColumnName="Remark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="SubmissionDate" msprop:Generator_ColumnVarNameInTable="columnSubmissionDate" msprop:Generator_ColumnPropNameInRow="SubmissionDate" msprop:Generator_ColumnPropNameInTable="SubmissionDateColumn" msprop:Generator_UserColumnName="SubmissionDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RecommenderId" msprop:Generator_ColumnVarNameInTable="columnRecommenderId" msprop:Generator_ColumnPropNameInRow="RecommenderId" msprop:Generator_ColumnPropNameInTable="RecommenderIdColumn" msprop:Generator_UserColumnName="RecommenderId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RecommendDate" msprop:Generator_ColumnVarNameInTable="columnRecommendDate" msprop:Generator_ColumnPropNameInRow="RecommendDate" msprop:Generator_ColumnPropNameInTable="RecommendDateColumn" msprop:Generator_UserColumnName="RecommendDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ApproverId" msprop:Generator_ColumnVarNameInTable="columnApproverId" msprop:Generator_ColumnPropNameInRow="ApproverId" msprop:Generator_ColumnPropNameInTable="ApproverIdColumn" msprop:Generator_UserColumnName="ApproverId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ApprovingDate" msprop:Generator_ColumnVarNameInTable="columnApprovingDate" msprop:Generator_ColumnPropNameInRow="ApprovingDate" msprop:Generator_ColumnPropNameInTable="ApprovingDateColumn" msprop:Generator_UserColumnName="ApprovingDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RejectorId" msprop:Generator_ColumnVarNameInTable="columnRejectorId" msprop:Generator_ColumnPropNameInRow="RejectorId" msprop:Generator_ColumnPropNameInTable="RejectorIdColumn" msprop:Generator_UserColumnName="RejectorId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RejectionDate" msprop:Generator_ColumnVarNameInTable="columnRejectionDate" msprop:Generator_ColumnPropNameInRow="RejectionDate" msprop:Generator_ColumnPropNameInTable="RejectionDateColumn" msprop:Generator_UserColumnName="RejectionDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RejectReason" msprop:Generator_ColumnVarNameInTable="columnRejectReason" msprop:Generator_ColumnPropNameInRow="RejectReason" msprop:Generator_ColumnPropNameInTable="RejectReasonColumn" msprop:Generator_UserColumnName="RejectReason" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Exported" msprop:Generator_ColumnVarNameInTable="columnExported" msprop:Generator_ColumnPropNameInRow="Exported" msprop:Generator_ColumnPropNameInTable="ExportedColumn" msprop:Generator_UserColumnName="Exported" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Claim" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
</xs:schema>